How to Work with RStudio and SQL Server
Learn how to get started running R scripts in R/Studio for data analysis.
Segments for Protection
Computer network security is important, and it's something we ought to be more concerned with as data professionals.
Data Encoding Schemes
Your choice of how you encode data can be significant. With computers and databases, you have a wide range of options. As a programmer, you will likely be called upon at some time in your career to design and coding scheme for particular application. It would really help if you at least avoided designing a bad one.
Three Times a Day
The latest work trend report from Microsoft shows people have peak work three times a day, and often out of normal working hours.
Why Clone Fails: Discovering the Hardware Beneath Azure SQL MI
In this next part of the series on Managed Instance, we see how to discover a bit about the internals of how the instance is being run. Learn how to kill and respawn a Managed Instance.
Retrieving SQL Server Index Properties with INDEXPROPERTY
SQL Server has several functions to assist with meta data about the server, databases, indexes, and more. In this tip, we will look at how to get index information for indexes in a database using the INDEXPROPERTY function.
Stairway to Transaction Log Management in SQL Server, Level 5: Managing the Log in Full Recovery Mode
In FULL recovery mode it is possible to do a point-in-time restore of a database. It is thankfully a rare event. Tony explains what's involved
The Technical Debt Anchor
Technical debt is something all of us deal with in our systems, and today Steve has a few thoughts on the impact of debt on database sysstems.
SQL Server Developer Standard Edition: A Gift to Developers!
Starting in SQL Server 2025, a new edition is available for installation: SQL Server Developer Standard Edition. This article dives into this edition, the problems it solves, and why it is a great addition for development teams that use SQL Server!
Blogs
Salesforce CDC Data Integration
By Rayis Imayev
(2025-June-30) Working with different abbreviations or acronyms can speed up communication, but at the same...
EightKB 2025 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2025 Edition has been announced!...
Why Not Just Use VARCHAR(MAX)?
A while ago I was looking into some odd errors that were cropping up...
Forums
Connecting ADF to take information from sharepoint and from Confluence
Dears, Hope this message finds you well Using Azure Data Factory, Issue 1: I...
Don't want to connect to the high transactional on-premises SQL Server Database
Dears, Hope this message finds you well We have a on-premises transactional database which...
Need help in changing my displayname
How do I change my display name, in my edit profile there are only...
Question of the Day
Finding Heaps
If I am querying DMVs for a heap, what do I look for?
See possible answers